﻿
IF object_id(N'dbo.[UDS_SMS_MobileMsgSendHistory]', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_SMS_MobileMsgSendHistory] (
        [MsgID]             numeric(10,0) NOT NULL,
        [Sender]            nvarchar(25)   COLLATE Chinese_PRC_CI_AS NULL,
        [Content]           nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
        [RecipientMobileNo] nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [SendTime]          datetime      NULL,
        [ResultCode]        int           NULL CONSTRAINT [DF_UDS_SMS_MobileMsgSendHistory_ResultCode] default(((0)))
    );
END
GO
